Go to the documentation of this file.
00001 using System;
00002 using System.Collections.Generic;
00003 using System.Linq;
00004 using System.Text;
00005 
00006 namespace FillCustomQueryTableCL
00007 {
00008     public class StatisticsQuery : PreselectionListQuery
00009     {
00010         private static string QueryTypeName = "Statistics";
00011         private static string GetParametersQuery =
00012             "SELECT " +
00013             "    0 FromMask, " +
00014             "    [Dynamic Mask Filter].[Dynamic Mask Filter Name] [Name], " +
00015             "    [Dynamic Mask Filter].[Order], " +
00016             "    min([Dynamic Mask Filter].[Query Name]) RelatedQuery, " +
00017             "    min([Dynamic Mask Filter].[FK Table ID]) RelatedTable " +
00018             "FROM [Dynamic Mask Filter] " +
00019             "    LEFT JOIN [Dynamic Mask] on [PK Dynamic Mask ID]=[FK Dynamic Mask ID] " +
00020             "    LEFT JOIN [Dynamic Mask Type] on [PK Dynamic Mask Type ID]=[FK Dynamic Mask Type ID] " +
00021             "WHERE [Dynamic Mask].[Query Name]='{0}' and [Use In Query]=1" +
00022             "GROUP BY [Dynamic Mask Filter].[Dynamic Mask Filter Name], [Dynamic Mask Filter].[Order]" +
00023             "UNION " +
00024             "SELECT " +
00025             "    1 FromSys, sys.parameters.name [Name], sys.parameters.parameter_id, " +
00026             "    sys.types.name TypeName, null " +
00027             "FROM sys.parameters  " +
00028             "    LEFT JOIN sys.objects on sys.parameters.object_id=sys.objects.object_id  " +
00029             "    LEFT JOIN sys.types ON sys.parameters.user_type_id=sys.types.user_type_id  " +
00030             "WHERE sys.objects.name='{0}' " +
00031             "ORDER BY FromMask, [Dynamic Mask Filter].[Order] ";
00032 
00033         public StatisticsQuery(string name) : base(name, QueryTypeName, GetParametersQuery) { }
00034 
00035         protected override void PreСorrectParameters(System.Data.SqlClient.SqlDataReader reader)
00036         {
00037 
00038         }
00039         protected override void СorrectParameters()
00040         {
00041 
00042         }
00043     }
00044 }